ig.excel.SortConditionCollection`1
An ordered collection of sort conditions which are applied to a sort-able regions in a worksheet.
Remarks
The sort conditions in the collection are applied in order to the data.
Note: The collection can hold a maximum of 64 sort condition.
Dependencies
jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
The current widget has no options.
The current widget has no events.
-
add
- .add( sortableItem:ig.excel.T, sortCondition:ig.excel.SortCondition );
Adds a sort condition to the collection.
- sortableItem
- Type:ig.excel.T
- The sort-able item over which the sort condition will be applied.
- sortCondition
- Type:ig.excel.SortCondition
- The sort condition to apply to the sort-able item.
Exceptions
Exception Description ig.ArgumentNullException sortableItem is null. ig.ArgumentNullException sortCondition is null. ig.ArgumentException sortableItem is already has a sort condition applied to it in the collection. ig.InvalidOperationException There are already 64 sort conditions in the collection. See Also
-
addRange
- .addRange( entries:ig.IEnumerable`1 );
Adds a range of sort conditions to the collection.
- entries
- Type:ig.IEnumerable`1
- An enumberable of entries which contain the sort-able item over which the sort condition will be applied and the sort condition to apply to the sort-able item.
Exceptions
Exception Description ig.ArgumentNullException entries is null. ig.ArgumentNullException If any sort condition is null. ig.ArgumentException If any sortable item is already has a sort condition applied to it in the collection. ig.InvalidOperationException There are already 64 sort conditions in the collection. -
clear
- .clear( );
Clears the collection.
-
contains
- .contains( sortCondition:ig.excel.SortCondition );
- Return Type:
- boolean
- Return Type Description:
- True if the sort condition is in the collection; False otherwise.
Determines whether the specified sort condition is in the collection.
- sortCondition
- Type:ig.excel.SortCondition
- The sort condition to find in the collection.
Exceptions
Exception Description ig.ArgumentNullException sortCondition is null. See Also
-
contains
- .contains( sortableItem:ig.excel.T );
- Return Type:
- boolean
- Return Type Description:
- True if the sort-able item is in the collection; False otherwise.
Determines whether the specified sort-able item is in the collection.
- sortableItem
- Type:ig.excel.T
- The sort-able item to find in the collection.
Exceptions
Exception Description ig.ArgumentNullException sortableItem is null. -
count
- .count( );
Gets the number of sort conditions in the collection.
-
indexOf
- .indexOf( sortCondition:ig.excel.SortCondition );
- Return Type:
- number
- Return Type Description:
- The 0-based index of the specified sort condition in the collection or -1 if the item is not in the collection.
Gets the index of the specified sort condition in the collection.
- sortCondition
- Type:ig.excel.SortCondition
- The sort condition to find in the collection.
Exceptions
Exception Description ig.ArgumentNullException sortCondition is null. See Also
-
indexOf
- .indexOf( sortableItem:ig.excel.T );
- Return Type:
- number
- Return Type Description:
- The 0-based index of the specified sort-able item in the collection or -1 if the item is not in the collection.
Gets the index of the specified sort-able item in the collection.
- sortableItem
- Type:ig.excel.T
- The sort-able item to find in the collection.
Exceptions
Exception Description ig.ArgumentNullException sortableItem is null. -
insert
- .insert( index:number, sortableItem:ig.excel.T, sortCondition:ig.excel.SortCondition );
Inserts a sort condition into the collection.
- index
- Type:number
- The 0-based index where the sort condition should be inserted.
- sortableItem
- Type:ig.excel.T
- The sort-able item over which the sort condition will be applied.
- sortCondition
- Type:ig.excel.SortCondition
- The sort condition to apply to the sort-able item.
Exceptions
Exception Description ig.ArgumentOutOfRangeException index is less than 0 or greater than SortConditionCollection`1.count. ig.ArgumentNullException sortableItem is null. ig.ArgumentNullException sortCondition is null. ig.ArgumentException sortableItem is already has a sort condition applied to it in the collection. ig.InvalidOperationException There are already 64 sort conditions in the collection. See Also
-
insertRange
- .insertRange( index:number, entries:ig.IEnumerable`1 );
Inserts a range of sort conditions into the collection.
- index
- Type:number
- The 0-based index where the sort condition should be inserted.
- entries
- Type:ig.IEnumerable`1
- An enumberable of entries which contain the sort-able item over which the sort condition will be applied and the sort condition to apply to the sort-able item.
Exceptions
Exception Description ig.ArgumentOutOfRangeException index is less than 0 or greater than SortConditionCollection`1.count. ig.ArgumentNullException entries is null. ig.ArgumentNullException If any sort condition is null. ig.ArgumentException If any sortable item is already has a sort condition applied to it in the collection. ig.InvalidOperationException There are already 64 sort conditions in the collection. -
item
- .item( sortableItem:ig.excel.T );
- Return Type:
- ig.excel.SortCondition
- Return Type Description:
- Returns a SortCondition.
Gets the sort condition for the specified sort-able item.
- sortableItem
- Type:ig.excel.T
- The sort-able item for which to get or set the sort condition.
Exceptions
Exception Description ig.ArgumentNullException sortableItem is null. ig.InvalidOperationException The sort-able item is not already in the collection and there are already 64 sort conditions in the collection. See Also
-
item
- .item( sortableItem:ig.excel.T, value:ig.excel.SortCondition );
- Return Type:
- ig.excel.SortCondition
- Return Type Description:
- Returns a SortCondition.
Sets the sort condition for the specified sort-able item.
- sortableItem
- Type:ig.excel.T
- The sort-able item for which to get or set the sort condition.
- value
- Type:ig.excel.SortCondition
Exceptions
Exception Description ig.ArgumentNullException sortableItem is null. ig.InvalidOperationException The sort-able item is not already in the collection and there are already 64 sort conditions in the collection. See Also
-
item
- .item( index:number );
Gets the pair of item and sort condition at the specified index.
- index
- Type:number
- The index at which to get the pair of item and sort condition.
Exceptions
Exception Description ig.ArgumentNullException The Key or Value of the assigned value is null. ig.InvalidOperationException The Key of the assigned value already in the collection at a different index. -
item
- .item( index:number, value:ig.KeyValuePair`2 );
Sets the pair of item and sort condition at the specified index.
- index
- Type:number
- The index at which to get the pair of item and sort condition.
- value
- Type:ig.KeyValuePair`2
Exceptions
Exception Description ig.ArgumentNullException The Key or Value of the assigned value is null. ig.InvalidOperationException The Key of the assigned value already in the collection at a different index. -
remove
- .remove( sortableItem:ig.excel.T );
- Return Type:
- boolean
- Return Type Description:
- True if the sort-able item was found and removed; False otherwise.
Removes a sort-able item from the collection.
- sortableItem
- Type:ig.excel.T
- The sort-able item to remove from the collection.
Exceptions
Exception Description ig.ArgumentNullException sortableItem is null. -
remove
- .remove( sortCondition:ig.excel.SortCondition );
- Return Type:
- boolean
- Return Type Description:
- True if the sort condition was found and removed; False otherwise.
Removes a sort condition from the collection.
- sortCondition
- Type:ig.excel.SortCondition
- The sort condition to remove from the collection.
Exceptions
Exception Description ig.ArgumentNullException sortCondition is null. See Also
-
removeAt
- .removeAt( index:number );
Removes the sort condition at the specified index.
- index
- Type:number
- The 0-based index of the sort condition to remove.
Exceptions
Exception Description ig.ArgumentOutOfRangeException index is less than 0 or greater than or equal to SortConditionCollection`1.count. -
replaceAll
- .replaceAll( entries:ig.IEnumerable`1 );
Clears the existing sort conditions from the collection and replaces them with new entries in a single atomic operation.
- entries
- Type:ig.IEnumerable`1
- An enumberable of entries which contain the sort-able item over which the sort condition will be applied and the sort condition to apply to the sort-able item.
Exceptions
Exception Description ig.ArgumentNullException entries is null. ig.ArgumentNullException If any sort condition is null. ig.ArgumentException If any sortable item is already has a sort condition applied to it in the collection. ig.InvalidOperationException There are more than 64 sort conditions.